CREATE TABLE [dbo].[Website]
(
[WebsiteKey] [uniqueidentifier] NOT NULL,
[SiteName] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[WebsiteRootURL] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[SecureWebsiteRootURL] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[PublishServerCode] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[PublishRootPath] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ProtectedRootPath] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AutomaticBatchPublishingFlag] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Website_AutomaticBatchPublishingFlag] DEFAULT ('N'),
[RelatedContentTitle] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ShowSummaryOnComboFlag] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Website_ShowSummaryOnComboFlag] DEFAULT ('N'),
[ShowSummaryOnListFlag] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Website_ShowSummaryOnListFlag] DEFAULT ('N'),
[ShowBreadCrumbFlag] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Website_ShowBreadCrumbFlag] DEFAULT ('N'),
[SiteStyleSheet] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UseTaggingFlag] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ListSortColumn] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TemplateHeaderFileName] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TemplateFooterFileName] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NavPublishDirectory] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ContentFolderPublishDirectory] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DefaultFileName] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[RelatedFilesTitle] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[RelatedLinksTitle] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UsePopupMenuFlag] [bit] NOT NULL CONSTRAINT [DF_Website_UsePopupMenuFlag] DEFAULT ((0)),
[HierMenuTopStartPosition] [int] NULL,
[HierMenuLeftStartPosition] [int] NULL,
[HighestToolbarLevelInd] [nchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ScreenResolutionCode] [nchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SimpleAdvancedInd] [nchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Website_SimpleAdvancedInd] DEFAULT ('S'),
[GraphicsDirectory] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DefaultSectionName] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DefaultSectionURL] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PrinterTemplateHeader] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PrinterTemplateFooter] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TextTemplateHeader] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TextTemplateFooter] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ActiveFlag] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Website_ActiveFlag] DEFAULT ('Y'),
[CreateDateTime] [datetime] NOT NULL CONSTRAINT [DF_Website_CreateDateTime] DEFAULT (getdate()),
[IncludeInCrossSiteSearchFlag] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Website_IncludeInCrossSiteSearchFlag] DEFAULT ('N'),
[UseCrossSiteSearchFlag] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Website_UseCrossSiteSearchFlag] DEFAULT ('N'),
[SearchResultAddlWeight] [smallint] NULL,
[DialogTemplateHeader] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DialogTemplateFooter] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MarkedForDeleteOn] [datetime] NULL,
[NavContentDisplayPath] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[FolderContentDisplayPath] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UseHierMenuFlag] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Website_UseHierMenuFlag] DEFAULT ('N'),
[UseAspNetTemplateFlag] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Website_UseAspNetTemplateFlag] DEFAULT ('N'),
[MasterPageFileName] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TextMasterPageFileName] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PrinterMasterPageFileName] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DialogMasterPageFileName] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[IsiMISWebsite] [bit] NOT NULL CONSTRAINT [DF_Website_IsiMISWebsite] DEFAULT ((0)),
[DefaultWebsiteFlag] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Website_DefaultWebsiteFlag] DEFAULT ('N')
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[Website] ADD CONSTRAINT [PK_Website] PRIMARY KEY CLUSTERED ([WebsiteKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_Website_ScreenResolutionCode] ON [dbo].[Website] ([ScreenResolutionCode]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Website] ADD CONSTRAINT [FK_Website_ScreenResolutionRef] FOREIGN KEY ([ScreenResolutionCode]) REFERENCES [dbo].[ScreenResolutionRef] ([ScreenResolutionCode])
GO
GRANT REFERENCES ON  [dbo].[Website] TO [IMIS]
GRANT SELECT ON  [dbo].[Website] TO [IMIS]
GRANT INSERT ON  [dbo].[Website] TO [IMIS]
GRANT DELETE ON  [dbo].[Website] TO [IMIS]
GRANT UPDATE ON  [dbo].[Website] TO [IMIS]
GO